a:11:{s:5:"Bdata";a:2:{s:8:"DataType";s:5:"TABLE";s:7:"DataExp";s:13:"mt_AnalyTable";}s:7:"dataSQL";a:2:{s:8:"DataType";s:3:"SQL";s:7:"DataExp";s:673:"select CJRQ,QY,ZT,KFS,LPMC,YT,XFYT,HX,sum(jzmj) as CJJM,sum(tnmj) as CJTM,0 AS GYJM,0 AS GYTM,0 AS QCJM,0 AS QCTM,sum(1) as CJTS,0 as QCTS,0 AS GYTS
FROM mt_AnalyTable
group by CJRQ,QY,ZT,KFS,LPMC,YT,XFYT,HX
union all
select GYRQ AS CJRQ,QY,ZT,KFS,LPMC,YT,XFYT,HX,0 as CJJM,0 as CJTM,sum(jzmj) as GYJM,sum(tnmj) as GYTM,0 AS QCJM,0 AS QCTM,0 as CJTS,0 as QCTS,sum(1) AS GYTS
from mt_SupplyTable
group by GYRQ,QY,ZT,KFS,LPMC,YT,XFYT,HX
union all
select '2014-09-01' AS CJRQ,QY,ZT,KFS,LPMC,YT,XFYT,HX,0 as CJJM,0 as CJTM,0 as GYJM,0 as GYTM,sum(jzmj) as QCJM,sum(tnmj) as QCTM,0 as CJTS,sum(1) as QCTS,0 AS GYTS
from mt_stocktable
group by QY,ZT,KFS,LPMC,YT,XFYT,HX";}s:5:"stock";a:2:{s:8:"DataType";s:6:"STORED";s:7:"DataExp";s:13:"NewCountStock";}s:9:"Spaceplus";a:2:{s:8:"DataType";s:3:"SQL";s:7:"DataExp";s:820:"SELECT
							order_no,
							DATE_FORMAT(c.addtime, '%Y-%m-%d') AS add_date,
							founding_status,
							a.user_name,
							a.business_id AS bnid,
							a.business_name AS bsname,
							a.addtime,
							a.cleartime,
							use_num,
							bc_name,
							b.counter_area_id AS areaID,
							b.id AS tbid,
							c.bill_no,
							bill_amount,
							goods_amount,
							gift_amount,
							whole_reduction,
							final_amount,
							is_pay,
							pay_time,
							bill_type,
							cash_pay,
							wechat_pay,
							alipay_pay,
							union_pay,
							member_card
						FROM
							spa_founding AS a
						INNER JOIN spa_counter_table AS b ON b.id = a.counter_table_id
						LEFT JOIN spa_bill AS c ON c.founding_id = a.id
						where c.addtime is not null or bill_amount>0";}s:2:"SY";a:2:{s:8:"DataType";s:5:"TABLE";s:7:"DataExp";s:17:"spa_sy_statistics";}s:2:"HY";a:2:{s:8:"DataType";s:5:"TABLE";s:7:"DataExp";s:15:"spa_user_deduct";}s:3:"YWY";a:2:{s:8:"DataType";s:3:"SQL";s:7:"DataExp";s:390:"SELECT
	b.id,
	b.bill_no,
	b.bill_amount,
	b.goods_amount,
	b.gift_amount,
	b.whole_reduction,
	b.final_amount,
	b.alipay_pay,
	b.wechat_pay,
	b.union_pay,
	b.cash_pay,
	b.member_card,
	b.business_id,
	s1.`name`
FROM
	spa_bill AS b
INNER JOIN spa_staff AS s1 ON s1.id = b.business_id
WHERE
	b.is_pay = 1
AND b.is_audit = 1
AND b.is_charge = 0
AND b.delete_time IS NULL";}s:5:"GOODS";a:2:{s:8:"DataType";s:5:"TABLE";s:7:"DataExp";s:20:"spa_goods_statistics";}s:4:"BACK";a:2:{s:8:"DataType";s:5:"TABLE";s:7:"DataExp";s:17:"spa_tc_statistics";}s:4:"GIFT";a:2:{s:8:"DataType";s:5:"TABLE";s:7:"DataExp";s:19:"spa_gift_statistics";}s:7:"DAYSELL";a:2:{s:8:"DataType";s:5:"TABLE";s:7:"DataExp";s:19:"spa_sell_statistics";}}